Powered by Easy Locator - fast results (0.0087 seconds).

DEBUGING
Address: Cambridge 02139
Full Address:
Username: DanOen
Lat: 42.3646
Lon: -71.1028
Geo Source:
Query: SELECT DISTINCT locations.id, locations.location_number, locations.name, locations.street_address, locations.street_address_line2, locations.street_address_line3, locations.city, locations.state_province, locations.zip_postal_code, locations.country, locations.phone, locations.toll_free, locations.fax, locations.email, locations.website_url, locations.contact_name, locations.contact_title, locations.additional_info, locations.custom1, locations.custom2, locations.custom3, locations.custom4, locations.custom5, locations.custom6, locations.image, locations.marker_url, locations.featured, locations.rank, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((42.3646 - locations.lat) * pi()/180 / 2), 2) + COS(42.3646 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-71.1028 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'DanOen' AND `locations`.`lat` <> "" ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 10
Total Rows: 9
Rows: Array ( [0] => stdClass Object ( [id] => 20756601 [location_number] => [name] => ACASA - North Chicago [street_address] => Coming Soon! [street_address_line2] => [street_address_line3] => [city] => Chicago [state_province] => Illinois [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 42.347183 [lon] => -87.838760 [distance] => 852.5300253796762 ) [1] => stdClass Object ( [id] => 20756542 [location_number] => [name] => ACASA - North Atlanta, GA [street_address] => 125 Town Park Drive [street_address_line2] => Suite #300 [street_address_line3] => [city] => Kennesaw [state_province] => Georgia [zip_postal_code] => 30144 [country] => USA [phone] => 470-450-2288 [toll_free] => [fax] => [email] => [website_url] => https://northatlanta.acasaseniorcare.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 34.038551 [lon] => -84.566536 [distance] => 927.6381813167588 ) [2] => stdClass Object ( [id] => 20756505 [location_number] => [name] => ACASA - Tampa Bay, FL [street_address] => 13134 Vail Ridge Drive [street_address_line2] => [street_address_line3] => [city] => Riverview [state_province] => Florida [zip_postal_code] => 33579 [country] => USA [phone] => 888-914-2288 [toll_free] => [fax] => [email] => [website_url] => https://tampabay.acasaseniorcare.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 27.914015 [lon] => -82.224876 [distance] => 1176.527666616329 ) [3] => stdClass Object ( [id] => 20756461 [location_number] => [name] => ACASA - Fort Myers, FL [street_address] => 17000 Alico Commerce Court [street_address_line2] => Suite #103 [street_address_line3] => [city] => Fort Myers [state_province] => Florida [zip_postal_code] => 33967 [country] => USA [phone] => 239-266-2288 [toll_free] => [fax] => [email] => [website_url] => www.acasaswfl.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 26.877794 [lon] => -82.209068 [distance] => 1239.0649271013099 ) [4] => stdClass Object ( [id] => 20756441 [location_number] => [name] => ACASA - Denver, CO [street_address] => Coming Soon! [street_address_line2] => [street_address_line3] => [city] => Denver [state_province] => Colorado [zip_postal_code] => [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 39.622532 [lon] => -104.896721 [distance] => 1759.6208843639167 ) [5] => stdClass Object ( [id] => 20756706 [location_number] => [name] => ACASA - St. George, UT [street_address] => Coming Soon! [street_address_line2] => [street_address_line3] => [city] => St. George [state_province] => Utah [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 40.477852 [lon] => -111.886169 [distance] => 2095.2570306528864 ) [6] => stdClass Object ( [id] => 20756622 [location_number] => [name] => ACASA - Henderson, NV [street_address] => 871 Coronado Center Dr [street_address_line2] => Suite #200 [street_address_line3] => [city] => Henderson [state_province] => Nevada [zip_postal_code] => 89052 [country] => USA [phone] => 702-718-2288 [toll_free] => [fax] => [email] => [website_url] => https://henderson.acasaseniorcare.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 36.000084 [lon] => -115.110374 [distance] => 2368.8384019199107 ) [7] => stdClass Object ( [id] => 20756343 [location_number] => [name] => ACASA - Anaheim, CA [street_address] => Coming Soon! [street_address_line2] => [street_address_line3] => [city] => Anaheim [state_province] => California [zip_postal_code] => [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 33.806877 [lon] => -117.917793 [distance] => 2577.956820760631 ) [8] => stdClass Object ( [id] => 20756402 [location_number] => [name] => ACASA - Newport Beach, CA [street_address] => Coming Soon! [street_address_line2] => [street_address_line3] => [city] => Newport Beach [state_province] => California [zip_postal_code] => [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 33.626057 [lon] => -117.839989 [distance] => 2579.745522868631 ) )